Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum


  

PreviousPrevious NextNext


~Samuel Nimfookonyettu 12.Jan.04 04:54 PM a Web browser
Domino Designer 6.0.3 Windows XP


I'm trying to experiment using ODBC. After they installed SQL server on my local machine, I could see the local database fine using Microsoft SQL Enterprise Manager v8.0. I can loop through the records using the Microsoft product without a problem.

In LotusScript, however, I'm getting a Notes system dump in the IBM_TECHNICAL_SUPPORT subdirectory every time I run the code. It happens on a specific ID in the file although the ID changes if I retrieve a different range of items.

The 1MB file has some fatal errors about "Exception code: c0000005 (ACCESS_VIOLATION)" although I can access the record from the MS product.

The code at this point has been whacked down to something bare bones and even that's getting the error. The loop that it dies in is shown below. Nothing fancy here! It's straight from the book.
Do
rc = result.NextRow
ID = result.GetValue("id", id)
Print "(4) ID=" & ID
Loop Until result.IsEndOfData

I've tested the rc variable and there's nothing unusual there -- it's -1 (true) for all of the records. It gets down to a particular ID (116783) and then immediately dies. I'm able to access this record and the next from the MS tool.

Any suggestions as to what I should be checking for?






Notes dump using ODBC (~Samuel Nimfook... 12.Jan.04)
. . RE: Notes dump using ODBC (~Bill Frokimari... 12.Jan.04)





  Document options
Print this pagePrint this page

 Search this forum

  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Category
Platform
Release
Advanced search

 RSS feedsRSS
All forum posts RSS
All main topics RSS